package com.zxk.api.dao;

import com.zxk.core.common.model.FundAnalysise;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface FundAnalysiseDao extends JpaRepository<FundAnalysise,Long> {
    @Query(value = "select * from fund_analysise b where b.fund_code =:fundCode and b.create_time like %:date%",nativeQuery = true)
    List<FundAnalysise> findByTimeBlur(@Param("fundCode") String fundCode, @Param("date") String date);

//    https://blog.csdn.net/qq_38408785/article/details/102863190?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159871008019724811860470%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=159871008019724811860470&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~rank_business_v1-1-102863190.ecpm_v3_rank_business_v1&utm_term=JpaRepository查找区间&spm=1018.2118.3001.4187

}
